============================================================================== Simba Apache Hive ODBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Apache Hive ODBC Connector 2.8.0, as well as the version history. 2.8.0 ======================================================================== Released 2024-06-21 Enhancements & New Features * [HAR-1400] Updated platform support The connector now supports the following platform versions: - Windows 11 - Windows Server 2022 - Debian 11 - Red Hat® Enterprise Linux® (RHEL) 8 and 9 - Ubuntu 22.04 and 24.04 - macOS 13 (Universal Binary – Intel and ARM support) - IBM AIX 7.1 and 7.2 For a list of supported platform versions, see the Installation and Configuration Guide. * [HAR-1392] Upgraded Visual Studio support The connector now uses Windows Visual Studio 2022. For supported versions, see the Installation and Configuration Guide. * [HAR-1392] Security updates The connector has been updated with security improvements. * [HAR-1392] Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.2 (previously 2.5.0) - libcURL 8.7.1 (previously 8.1.2) - OpenSSL 3.0.13 (previously 3.0.9) - Zlib 1.3.1 (previously 1.2.13) * [HAR-1392] Updated security flags The following security flags have been used to improve security checks in the connector: - /CETCOMPAT - /CFG - /Qspectre - /SDL Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * [HAR-1171] The Hive server does not currently support using scientific notation for FLOAT type. As a workaround, to use scientific notation, cast the data to a DECIMAL. For example: SELECT CAST(3.33333e-07 AS DECIMAL) * On Hive 3.0 and later, when the server does not set the metastore schema reader properly, the connector returns the following error: Error from server: error code: '0' error message: 'MetaException(message:java.lang.UnsupportedOperationException: Storage schema reading not supported)' To resolve this issue, set the following in the Hive server: metastore.storage.schema.reader.impl= org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 2.8.0 ------------------------------------------------------------------------ * [HAR-1400] Removed support for earlier versions of platform Beginning with this release, the connector no longer supports the following versions of platform: - Windows 8.1 - Windows Server 2012 - Debian 8 and 9 - Red Hat® Enterprise Linux® (RHEL) 7 - Ubuntu 18.04 - IBM AIX 5.3 and 6.1 For a list of supported platform versions, see the Installation and Configuration Guide. * [HAR-1392] Removed Visual Studio 2015 support Beginning with this release, the connector no longer supports Visual Studio 2015. For information about the supported Visual C++ Redistributable for Visual Studio versions, see the Installation and Configuration Guide. 2.7.0 ------------------------------------------------------------------------ * [HAR-1346] Updated SAML SSO cookie cache option When using SAML SSO cookie cache with SAML SSO authentication, the username and password are now optional for the Windows platform. * [HAR-1350] Removed support for macOS universal bitness Beginning with this release, the connector no longer supports universal bitness for macOS. Support for macOS versions 10.14 and 10.15 have been removed. For a list of supported macOS versions, see the Installation and Configuration Guide. 2.6.15 ----------------------------------------------------------------------- * [HAR-1271] Updated HTTPAuthCookies default value The default value for HTTPAuthCookies is now hive.server2.auth,JSessionID, KNOXSESSIONID,KNOX_BACKEND-HIVE. Previously, the default value for HTTPAuthCookies was hive.server2.auth,JSessionID. For more information, see the Installation and Configuration Guide. * [HAR-1315] Updated QueryTimeoutOverride default value The default value for QueryTimeoutOverride is now an empty string. Previously, the default value for QueryTimeoutOverride was Zero. For more information, see the Installation and Configuration Guide. * [HAR-1316] Updated SSOIgnoreDriverNoPrompt default value The default value for SSOIgnoreDriverNoPrompt is now true. Previously, the default value for SSOIgnoreDriverNoPrompt was false. For more information, see the Installation and Configuration Guide. 2.6.12 ----------------------------------------------------------------------- * [HAR-1082][HAR-1087][HAR-1089][HAR-1224][HAR-1229][HAR-1230][HAR-1231] Removed support for OS platforms Beginning with this release, the connector no longer supports the following OS platforms: - Windows 7 - Windows Server 2008 and 2008 r2 - macOS 10.9, 10.10, 10.11, and 10.12 - CentOS 6 / RHEL 6 - SLES 11 - Ubuntu 14.04 and 16.04 - Debian 6 and 7 For a list of supported OS versions, see the Installation and Configuration Guide. * [HAR-1095] Removed support for Visual C++ Redistributable for Visual Studio 2013 Beginning with this release, the connector no longer supports this version of the dependency and requires Visual C++ Redistributable for Visual Studio 2015 instead. For information about the supported Visual C++ Redistributable for Visual Studio versions, see the Installation and Configuration Guide. 2.6.8 ------------------------------------------------------------------------ * Removed support for Apache Hive versions earlier than 1.0.0 Beginning with this release, the driver no longer supports Apache Hive versions earlier than 1.0.0. For a list of supported Apache Hive versions, see the Installation and Configuration Guide. 2.6.0 ------------------------------------------------------------------------ * Minimum TLS Version Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2. To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide. Version History ============================================================== 2.7.0 ------------------------------------------------------------------------ Released 2023-06-23 Enhancements & New Features * [HAR-1344][HAR-1349][HAR-1351] Updated third-party libraries The connector now uses the following third-party libraries: - Apache Thrift 0.17.0 (previously 0.9.0) - Apache ZooKeeper 3.7.1 (previously 3.4.6) - Boost 1.81.0 (previously 1.64.0) - cyrus sasl 2.1.28 (previously 2.1.26) - Expat 2.5.0 (previously 2.4.6) - ICU 71.1 (previously 58.2.x) - libcURL 8.1.2 (previously 7.84.0) - lz4 1.9.4 (previously 1.9.3) - OpenSSL 3.0.9 (previously 1.1.1s) - Simba Engine SDK 10.2 (previously 10.1) - Zlib 1.2.13 (previously 1.2.11) * [HAR-1272] Updated Hive server version support The connector now supports Apache Hive server versions 1.0 through 3.1.3. For a list of supported Hive server versions, see the Installation and Configuration Guide. * [HAR-1343] Updated BDS support For BDS specific server-side properties, adding the SSP_prefix is no longer required. The connector also does not convert the BDS specific server-side property key names to lower case characters. * [HAR-1350] Updated macOS support On macOS, the connector is now a Universal driver that natively supports Apple Silicon. For security best practices, it is suggested to keep both the connector and OS updated. Resolved Issues The following issues have been resolved in Simba Apache Hive ODBC Connector 2.7.0. * [HAR-1325][HAR-1330] When executing a query with CREATE TABLE AS SELECT, the connector refers to a schema as an invalid table and returns an error. * [HAR-1337] When in ZooKeeper discovery mode and a network error occurs, the connector does not connect to the same HS2 instance on a reconnecting attempt. 2.6.16 ----------------------------------------------------------------------- Released 2023-02-17 Resolved Issues The following issue has been resolved in Simba Apache Hive ODBC Connector 2.6.16. * [HAR-1335] In some cases, when handling primary keys and foreign keys catalog functions, the connector terminates unexpectedly. 2.6.15 ----------------------------------------------------------------------- Released 2023-01-24 Enhancements & New Features * [HAR-1311] Updated OpenSSL support The connector now uses OpenSSL version 1.1.1s. Previously, the connector used OpenSSL version 1.1.1q. * [HAR-1314] SAML SSO cookie cache support You can now avoid invoking multiple browser prompts when connecting with SAML SSO authentication to create multiple connections within the same application using the same DSN or connection string. To do this, select the Enable Auth Cookie Caching checkbox (set the EnableSamlCookieCaching property to 1). For more information, see the Installation and Configuration Guide. Resolved Issues The following issue has been resolved in Simba Apache Hive ODBC Connector 2.6.15. * [HAR-1323] The REMARKS column of the tables metadata does not populate with comments. ==============================================================================